USE [DTP]
GO

/****** Object:  StoredProcedure [dbo].[GetAccidentData]    Script Date: 11/26/2010 15:22:17 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


ALTER PROCEDURE [dbo].[GetVehicleList]
	@id bigint
AS
	SELECT
	t_AccidentToVehicle.VehicleId,
	t_VehicleCards.carIdNumber
		
	FROM dbo.t_AccidentToVehicle 
	INNER JOIN t_VehicleCards  ON t_AccidentToVehicle.VehicleId = t_VehicleCards.id 		
	WHERE t_AccidentToVehicle.Deleted = 0 AND t_AccidentToVehicle.id >= @id
			


GO


